Skip to main content
Feedback

Cross reference table example: Using runtime values

In this example the cross reference table's first row uses values that come from a Runtime.

In this state cross reference table example, system A uses the State Name value from the conKeyRefs.UC_Runtime DocconKeyRefs.UC_Runtime-2.

For example, when referring to the U.S. states:

  • System A uses the State Name value

  • System B uses the FIPS Alpha Code value

When mapping from System A to System B, you need to translate the State Name value to the FIPS Alpha Code value. The SQL Select statement for the Runtime-specific Output_Element would be: SELECT FIPS_Alpha_Code FROM Cross_Reference_Table WHERE State_Name=Input_Element AND {conKeyRefs.UC_Runtime}=<{conKeyRefs.UC_Runtime} Name> {conKeyRefs.UC_Runtime}=<Default>.

If the State Name=Alabama in System A and the Runtime Name=DocAtom-2, then the FIPS Alpha Code=AL for System B. "AL" is the value that is returned in the output.

If the State Name=Alabama in System A and the Runtime Name=Default, then the FIPS Alpha Code=ALA for System B. "ALA" is the value that is returned in the output.